﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[spCreateDirectory]
#-- Purpose:		Creates a backup subdirectory for a database
#--	Last Update:	04/27/2012
#--					For a complete history - please review comments in Version
#--					control.
#-- Required XPs:	master.dbo.xp_create_subdir
#-- Called By:		[dbo].[spBackupFull]
#--					[dbo].[spBackupDifferential]
#--					[dbo].[spBackupLog]
#------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[spCreateDirectory]
(
	@backup_directory_name		varchar(8000)
)
WITH EXECUTE AS OWNER
AS
BEGIN
	EXEC	master.dbo.xp_create_subdir @backup_directory_name
END
